package com.example.mybatisdemo.mapper;

import com.example.mybatisdemo.model.ArticleInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ArticleInfoMapper {
    @Select("select *from article_info ta " +
            "left JOIN user_info tb ON ta.uid = tb.id " +
            "WHERE ta.id = 1 ")
    ArticleInfo selectArticleInfoAndUserInfo(Integer id);
}
